﻿create proc thuan_qtloaddanhsachmenu
as
select a.MenuID,a.TenMenu,a.DienGiai,a.TenModule,a.TenThuMuc,a.TenForm,a.Hinh,a.MaLoaiMenu,b.DienGiai as TenLoai
from DanhMuc_Menu a,DanhMuc_LoaiMenu b
Where a.MaLoaiMenu=b.MaLoaiMenu
order by a.MaLoaiMenu,a.MenuID
